package com.group2.mapper;

import com.group2.bean.KeywordBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @author 高耀
 * @date 2024/12/17 15:56<p></p>
 */
@Mapper
public interface KeywordStaticMapper {
    @Select("select " +
            "`keyword`, " +
            "sum(keyword_count) AS `value` " +
            "from dws_traffic_source_keyword_page_view_window " +
            "partition par#{date} " +
            "group by `keyword` ")
    public List<KeywordBean> selectKeywordStatic(Integer date);
}
